In this video, you'll
learn how to build an approval request using a
business friendly scenario. This scenario allows
anyone who has access to the Microsoft SharePoint list to contribute tweets without
knowing anything about Twitter. In this example, the
social media team at Contoso can then approve
or reject the tweets. This means that they
remain in control of the account and the content
that goes out to customers. Let's start by creating
the SharePoint list. First, opened the
Microsoft apps menu and open the lists app. Click ''New list'' to
create a new list, and then select ''Blank
list'' from the dialog box. Here you can give
your list a name, description, color, and icon. Click ''Create'' to start
editing your new list, then select ''Add Column''
to open the drop-down menu. First, select multiple lines of text to add this column
type to the list. You can provide a
name, description, and default value
in the column pane. This column will
hold the content of the tweets that would
be approved to later. Click ''Save'' to create
and add the column. Next, add a date and time column and provide the
necessary details. Now, add a yes/no column, this enables an
approver to select yes or no to approve
or reject the tweet. Finally, add a single
line of text column. With this, the approver
will be able to add a comment about
the approval status. Now, copy the URL of
the SharePoint list. You will use it when
you create the flow. Now you can create an
approval request flow. First, sign into Power Automate and
select ''Templates''. Search for and select the post list items to Twitter
after approval template, make sure that your
account credentials for SharePoint approvals and
Twitter are correct. Then select ''Continue''. The framework for the flow
appears on the screen. Now in your Microsoft Flow and the when a new item
is created action, enter the following values
in the two required fields. The URL of your team's
SharePoint site in the site address. Select it from the suggestion
list if that appears, and select or type ContosoTweets
under the list name. Next, you will add details to the Start an
approval action box. If all the fields
are not visible, you may need to click
on the ''Edit'' link. When you click into the
first field in this box, in the title field, you should see a list of dynamic content
automatically appear. Enter new tweet for
in the title field, then select ''Title'' in
the dynamic content list. In the assigned to field, enter and select the
name of a test user. Now remove the default items in the details field and
add TweetContent, TweetDate, and created by DisplayName from the
dynamic content list. In order to make
this more readable, add the word on before tweet, date, and by before
created by display name. In the item link field, paste the URL of your SharePoint list which you copied in the
previous procedure. Now enter the ContosoTweet list in the item link
descriptions field. In the condition action, hover over the If yes box and
select ''Add an action''. Search for update
item and select the SharePoint connector,
update item action. Enter the URL of the team's SharePoint site
again in the site address. Now, select ContosoTweet
again in the list name field. In the ID field, add ID from the
dynamic content list. This ID field is used to match the actual tweet request
in the SharePoint list. Select the title field, and then in the dynamic content
list, search for title. Now, add title from the when a new item
is created action, select ''Yes'' in the
approval status field. Then select the
approver comments field and add comments from the
dynamic content list. That's it. Well done. You've started building your
very first approval request in Microsoft Power Automate.